About 1,372,549 results (3,277 milliseconds)
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 ... The subquery can query other tables or ... database that uses snapshot isolation to handle multiple concurrent operations on a table.
Providing SELECT rights to a PG DB
https://groups.google.com/g/puppet-users/c/6x2jBEXn-lE Oct 20, 2016 ... Valid options: DATABASE, SCHEMA, SEQUENCE, ALL SEQUENCES IN SCHEMA, TABLE or ALL TABLES IN SCHEMA. ... TRUNCATE','REFERENCES','TRIGGER ...
Emptying / Deleting the process engine history tables in database
https://groups.google.com/g/camunda-bpm-users/c/DIeC8-PCiUk Dec 8, 2014 ... You should be able to safely delete all historic process instances (and activity instances, task instances) etc. for all process instances that have actually ...
Data manipulation language (DML) statements in GoogleSQL ...
https://cloud.google.com/bigquery/docs/reference/standard-sql/dml-syntax The TRUNCATE TABLE statement removes all rows from a table but leaves the table metadata intact, including the table schema, description, and labels. Note: This ...
Error truncating performance_schema tables
https://groups.google.com/g/google-cloud-sql-discuss/c/KmXOjqkSwzk To specify the table size explicitly, set the performance_schema_digests_size system variable at server startup. ... SQL, so this is what you should do if ...
Query multiple tables using a wildcard table | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/querying-wildcard-tables Wildcard tables enable you to query multiple tables using concise SQL statements. Wildcard tables are available only in GoogleSQL.
Purge history from rundeck due to extremely slow UI
https://groups.google.com/g/rundeck-discuss/c/W9sYZQK0dW8 Which tables should I truncate to remove some history? The two I think ... I can work out the SQL so table and column names would be most helpful.
Increase in the volume of lsn_time_mapping cdc table sql server
https://groups.google.com/g/debezium/c/6ctMoBuV-oY Oct 13, 2023 ... what is the impact of this table if we daily truncate the table in mignight. ... Not an expert here but from what I understand all the CDC related ...
Truncated Data on Migration
https://groups.google.com/g/web2py/c/tL8gnapo6fg/m/Q9jvAWomiWQJ On a recent schema migrate, web2py truncated all of these fields ... However, Oracle 9i has a max varchar length of 4000; SQL Server 2005 has a max of 8000; etc.
Snapshot alters my forgien keys.
https://groups.google.com/g/microsoft.public.sqlserver.replication/c/WQLykqoUQtM drop and then add again, all foreign keys to the subscription tables. Now I've goint to have to modifiy it for all constaints too. Why does SQL Server do this?
Linked Tables problem
https://groups.google.com/g/h2-database/c/zY-wYSCy6O8 All this can be done with 2 sentence is H2 (local database) like : CREATE LINKED TABLE TLKT.EMP('com.microsoft.sqlserver.jdbc.SQLServerDriver', 'jdbc:sqlserver ...
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 ...
Performance: DROP TABLE very slow on large tables
https://groups.google.com/g/h2-database/c/rVW-slB7KRY Then the db was ok again (i.e. responsive). While I was waiting all those hours I was browsing this forum and also looking for an alternative database product.
AUTOMATING Export and Import Of tables For CLOUD SQL ...
https://groups.google.com/g/google-cloud-sql-discuss/c/s0FL28vSTS8/m/zCh4xflSAwAJ ... SQL postgresql database ... - create the exports (DATA ONLY) of all 15 tables in SOURCE. - Connect to psql client to truncate these 15 table at the TARGET. - ...
Interview Questions - SQL Server Interview Questions/Answers Part-1
https://sites.google.com/site/interviewsharing/data-model/sql-server-interview-questions-answers-part-1 You can have a where clause in Delete statement where as Truncate statement cannot have a where clause. Truncate will delete all the rows in a Table, but the ...
FAQ | Datastream | Google Cloud
https://cloud.google.com/datastream/docs/faq By default, Datastream gets all historical data from the database tables of your source that you specify, in parallel to the CDC stream. Datastream provides you ...
Debezium Connector Aurora Postgres - Kafka: Not sending updates ...
https://groups.google.com/g/debezium/c/YHotnMwBIDk Jul 13, 2021 ... "database.server.name": "dbname", "schema.whitelist ... 4 - I execute a truncate table and I get all three previous messages on the topic.
Reinitiating Initial snapshot for specific table in source connector
https://groups.google.com/g/debezium/c/X9ovbeCfDkA Sep 7, 2023 ... Is it possible to trigger the initial snapshot multiple times for a source table? Scenario - I have a SQL SERVER source connector that includes ...
Managing partitioned tables | BigQuery | Google Cloud
https://cloud.google.com/bigquery/docs/managing-partitioned-tables For example, the following query lists all of the table partitions in the dataset named mydataset : ... To delete a partition in a partitioned table: Console SQL ...
Table chart options | Looker | Google Cloud
https://cloud.google.com/looker/docs/table-options Microsoft SQL Server (MSSQL) · MongoDB Connector for BI · MySQL · Oracle · Oracle ... tables to show all rows option is selected. See the downloading or ...