def create_table(
ctx,
dataset_id,
table_id,
path,
job_config_params,
partitioned,
if_table_exists,
force_dataset,
if_storage_data_exists,
if_table_config_exists,
):
Table(table_id=table_id, dataset_id=dataset_id, **ctx.obj).create(
path=path,
job_config_params=job_config_params,
partitioned=partitioned,
if_table_exists=if_table_exists,
force_dataset=force_dataset,
if_storage_data_exists=if_storage_data_exists,
if_table_config_exists=if_table_config_exists,
)
click.echo(
click.style(
f"Table `{dataset_id}_staging.{table_id}` was created in BigQuery",
fg="green",
))
def upload_table(ctx, dataset_id, table_id, filepath, partitions, if_exists):
blob_name = Table(dataset_id, table_id, **ctx.obj).append(
filepath=filepath, partitions=partitions, if_exists=if_exists
)
click.echo(click.style(f"Data was added to `{dataset_id}.{table_id}`", fg="green",))
def publish_table(ctx, dataset_id, table_id, if_exists):
Table(table_id=table_id, dataset_id=dataset_id,
**ctx.obj).publish(if_exists=if_exists, )
click.echo(
click.style(
f"Table `{dataset_id}.{table_id}` was published in BigQuery",
fg="green",
))
def update_table(ctx, dataset_id, table_id, mode):
Table(table_id=table_id, dataset_id=dataset_id,
**ctx.obj).update(mode=mode, )
click.echo(
click.style(
f"All tables `{dataset_id}*.{table_id}` were updated in BigQuery",
fg="green",
))
def init_table(ctx, dataset_id, table_id, data_sample_path, if_exists):
t = Table(table_id=table_id, dataset_id=dataset_id,
**ctx.obj).init(data_sample_path=data_sample_path,
if_exists=if_exists)
click.echo(
click.style(
f"Table `{table_id}` folder and metadata were created at {t.metadata_path}{dataset_id}",
fg="green",
))
def delete_table(ctx, dataset_id, table_id, mode):
Table(table_id=table_id, dataset_id=dataset_id,
**ctx.obj).delete(mode=mode, )