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, )