About 1,786,623 results (2,813 milliseconds)

Scheduling queries | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/scheduling-queries
Scheduled queries can create partitioned or non-partitioned destination tables. Partitioning is available in the Google Cloud console, bq command-line tool, and ...

Insert, update, and delete data using data manipulation language ...

https://cloud.google.com/spanner/docs/dml-tasks
To execute DML statements, use the gcloud spanner databases execute-sql command. The following example adds a new row to the Singers table. gcloud spanner ...

Work with multi-statement queries | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/multi-statement-queries
Delete temporary tables. You can delete a temporary table explicitly before the multi-statement query completes by using the DROP TABLE statement: CREATE ...

Simplest way to clear out all records in a database

https://groups.google.com/g/ica-atom-users/c/Obxqc0AmhAw
May 11, 2015 ... Simplest way to clear out all records in a database. 202 views. CSV-importSQLcommand-linepublication-status ... command-line task to delete all ...

cbt CLI reference | Cloud Bigtable Documentation | Google Cloud

https://cloud.google.com/bigtable/docs/cbt-reference
The cbt CLI is a command-line interface that lets you interact with Cloud Bigtable. ... Delete a table. cbt deletetable <table-id> Example: cbt deletetable mobile ...

Deleting labels | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/deleting-labels
You can delete a label from a dataset, table, or view by: Using the Google Cloud console; Using SQL DDL statements; Using the bq command-line tool's bq ...

Managing table data | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-table-data
... command-line tool ... table using data manipulation language (DML) statements in SQL. DML statements let you update, merge, insert, and delete rows in tables.

Quotas and limits | BigQuery | Google Cloud

https://cloud.google.com/bigquery/quotas
DROP ALL ROW ACCESS POLICIES statements per table per 10 seconds, 5 statements ... The limit includes SQL statements that create tables, such as CREATE TABLE and ...

Unable to delete community on DSpace UI

https://groups.google.com/g/dspace-tech/c/xdJ-JE9FXQI
please advise on how to delete one community using command line. the ... table using SQL like i have deleted all contents of communities2item table. Regards ...

Inserting, updating, and deleting data using the Google Cloud CLI ...

https://cloud.google.com/spanner/docs/modify-gcloud
To execute Data Manipulation Language (DML) statements, use the gcloud spanner databases execute-sql command . ... Delete a row from a table. To delete a row, you ...

Managing partitioned tables | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-partitioned-tables
Copy a partitioned table; Copy individual partitions; Delete a partition; Partitioned table security ... command- line tool. The following examples escape the ...

Manage datasets | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-datasets
When you delete a dataset by using the bq command-line tool, you must use the -r flag to delete the tables and views. Caution: Deleting a dataset is ...

Using the bq command-line tool | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/bq-command-line-tool
Relational database services for MySQL, PostgreSQL and SQL Server. Cloud SDK ... Delete table snapshots · Create periodic table snapshots. Manage jobs and ...

Modifying table schemas | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-table-schemas
Adding a REQUIRED column to an existing table schema in the API or bq command-line tool causes an error. However, you can create a nested REQUIRED column as ...

Managing views | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-views
You can update the SQL query used to define a view by: Using the Google Cloud console; Using the bq command-line tool's bq update command; Calling the tables.

bq command-line tool reference | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/reference/bq-cli-reference
Note: You can use the TRUNCATE TABLE statement to remove all rows from a table without deleting the schema. --schema={ SCHEMA_FILE | SCHEMA }. Specifies ...

Data manipulation language (DML) statements in GoogleSQL ...

https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax
If there is an UPDATE or DELETE clause in the MERGE statement: q' + t'. INSERT statement. Use the INSERT statement when you want to add new rows to a table.

Delete all rows in BigQuery and other DML statements to add ...

https://cloud.google.com/blog/topics/developers-practitioners/bigquery-explained-data-manipulation-dml
Nov 13, 2020 ... CREATE TABLE `project.dataset.product` ( sku STRING, description STRING, quantity FLOAT64, price FLOAT64, specs STRUCT< color STRING ...

Data definition language (DDL) statements in GoogleSQL ...

https://cloud.google.com/bigquery/docs/reference/standard-sql/data-definition-language
Key Point: This SQL statement uses the term SCHEMA to refer to a logical collection of tables, views, and other resources. The equivalent concept in BigQuery is ...

Manage tables | BigQuery | Google Cloud

https://cloud.google.com/bigquery/docs/managing-tables
To copy multiple source files to a destination table, you must use the bq command-line tool or the API. To copy a single source table: Console SQL ...