2024-09-12T19:47:07.349-06:00 1 [14|Q-Id] [INFO|Connec] Opened GoogleBigQuery connection. Version: 23.0.8749.0. Edition: [ADO.NET Provider .NET 4.0]. 2024-09-12T19:47:07.349-06:00 1 [14|Q-Id] [INFO|Connec] Connection String: allowaggregateparameters=False;allowedtabletypes=TABLE,EXTERNAL,VIEW,MATERIALIZED_VIEW;allowlargeresultsets=False;allowupdateswithoutkey=False;applicationname='';auditlimit=1000;auditmode='';authscheme=OAuthJWT;autocache=False;bigqueryoptions='';billingprojectid='';browsableschemas='';cacheconnection='';cachelocation="%APPDATA%\CData\GoogleBigQuery Data Provider";cachemetadata=False;cacheprovider='';cachetolerance=600;catalog=tfo-us-dev-synops-dl-raw;cdataapp=DataSync;connectionlifetime=0;datasetid=aimi;destinationtable='';filtercolumns='';firewallpassword=*****;firewallport=0;firewallserver='';firewalltype=NONE;firewalluser='';flattenobjects=True;gcsbucket='';gcsbucketfolder='';generateschemafiles=Never;initiateoauth=GETANDREFRESH;insertmode=Upload;location=C:\ProgramData\CData\sync\connections\dstAimi;logfile=D:\LogFiles\jobAimiClone_D_2024-09-12-19-47-06.log;logmodules='';maximumbillingtier='';maximumbytesbilled='';maxlogfilecount=-1;maxlogfilesize=100M;maxrows=-1;oauthaccesstoken=*****;oauthclientid='';oauthclientsecret=*****;oauthencryptkey=*****;oauthexpiresin=3599;oauthjwtcert=*****;oauthjwtcertpassword=*****;oauthjwtcertsubject=*;oauthjwtcerttype=GOOGLEJSON;oauthjwtissuer='';oauthjwtsubject='';oauthrefreshtoken=*****;oauthsettingslocation=C:\ProgramData\CData\sync\connections\dstAimi\oauth\oauthsettings.txt;oauthtokentimestamp=1726191915020;oauthverifier=*****;offline=False;other="cdataapp=DataSync";pagesize=100000;pollinginterval=1;poolidletimeout=60;poolmaxsize=100;poolminsize=1;poolwaittime=60;primarykeyidentifiers='';projectid=tfo-us-dev-synops-dl-raw;proxyauthscheme=BASIC;proxyautodetect=True;proxyexceptions='';proxypassword=*****;proxyport=80;proxyserver='';proxyssltype=AUTO;proxyuser='';pseudocolumns='';querypassthrough=False;readonly=False;refreshviewschemas=True;schema=aimi;scope='';showtabledescriptions=False;sslservercert=*****;storagepagesize=10000;storagethreshold=100000;storagetimeout=60;tables='';tablesamplepercent='';temptabledataset=_CDataTempTableDataset;timeout=300;usearrowformat=False;useconnectionpooling=False;uselegacysql=False;usequerycache=True;userdefinedviews='';usestorageapi=True;verbosity=2;views='';waitforbatchresults=True 2024-09-12T19:47:07.365-06:00 2 [14|Q-Id] [EXEC|Parsed] Executing query: [SELECT * FROM SYS_SQLINFO] 2024-09-12T19:47:07.365-06:00 2 [14|Q-Id] [EXEC|Messag] Executed query: [SELECT * FROM SYS_SQLINFO] Success: (16 ms) 2024-09-12T19:47:07.365-06:00 2 [14|Q-Id] [EXEC|Parsed] Executing query: [SELECT * FROM sys_tabletypes] 2024-09-12T19:47:07.365-06:00 2 [14|Q-Id] [EXEC|Messag] Executed query: [SELECT * FROM sys_tabletypes] Success: (0 ms) 2024-09-12T19:47:07.412-06:00 2 [14|Q-Id] [HTTP|Req: 4] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables?maxResults=1000 2024-09-12T19:47:07.564-06:00 2 [14|Q-Id] [HTTP|Res: 4] HTTP/1.1 200 OK, 1091 Bytes Transferred 2024-09-12T19:47:07.564-06:00 2 [14|Q-Id] [HTTP|Res: 4] Request completed in 199 ms. 2024-09-12T19:47:07.564-06:00 1 [14|Q-Id] [INFO|Connec] Closed GoogleBigQuery connection 2024-09-12T19:47:07.705-06:00 1 [15|Q-Id] [INFO|Connec] Opened GoogleBigQuery connection. Version: 23.0.8749.0. Edition: [ADO.NET Provider .NET 4.0]. 2024-09-12T19:47:07.705-06:00 1 [15|Q-Id] [INFO|Connec] Connection String: allowaggregateparameters=False;allowedtabletypes=TABLE,EXTERNAL,VIEW,MATERIALIZED_VIEW;allowlargeresultsets=False;allowupdateswithoutkey=False;applicationname='';auditlimit=1000;auditmode='';authscheme=OAuthJWT;autocache=False;bigqueryoptions='';billingprojectid='';browsableschemas='';cacheconnection='';cachelocation="%APPDATA%\CData\GoogleBigQuery Data Provider";cachemetadata=False;cachemetadataschema=false;cachemetadatatable=false;cachemetadatatablecolumns=false;cacheprovider='';cachetolerance=600;catalog=tfo-us-dev-synops-dl-raw;cdataapp=DataSync;connectionlifetime=0;datasetid=aimi;destinationtable='';filtercolumns='';firewallpassword=*****;firewallport=0;firewallserver='';firewalltype=NONE;firewalluser='';flattenobjects=True;gcsbucket='';gcsbucketfolder='';generateschemafiles=Never;initiateoauth=GETANDREFRESH;insertmode=Upload;location=C:\ProgramData\CData\sync\connections\dstAimi;logfile=D:\LogFiles\jobAimiClone_D_2024-09-12-19-47-06.log;logmodules='';maximumbillingtier='';maximumbytesbilled='';maxlogfilecount=-1;maxlogfilesize=100M;maxrows=-1;oauthaccesstoken=*****;oauthclientid='';oauthclientsecret=*****;oauthencryptkey=*****;oauthexpiresin=3599;oauthjwtcert=*****;oauthjwtcertpassword=*****;oauthjwtcertsubject=*;oauthjwtcerttype=GOOGLEJSON;oauthjwtissuer='';oauthjwtsubject='';oauthrefreshtoken=*****;oauthsettingslocation=C:\ProgramData\CData\sync\connections\dstAimi\oauth\oauthsettings.txt;oauthtokentimestamp=1726191915020;oauthverifier=*****;offline=False;other="cachemetadataschema=false;cachemetadatatable=false;cachemetadatatablecolumns=false;cdataapp=DataSync";pagesize=100000;pollinginterval=1;poolidletimeout=60;poolmaxsize=100;poolminsize=1;poolwaittime=60;primarykeyidentifiers='';projectid=tfo-us-dev-synops-dl-raw;proxyauthscheme=BASIC;proxyautodetect=True;proxyexceptions='';proxypassword=*****;proxyport=80;proxyserver='';proxyssltype=AUTO;proxyuser='';pseudocolumns='';querypassthrough=False;readonly=False;refreshviewschemas=True;schema=aimi;scope='';showtabledescriptions=False;sslservercert=*****;storagepagesize=10000;storagethreshold=100000;storagetimeout=60;tables='';tablesamplepercent='';temptabledataset=_CDataTempTableDataset;timeout=300;usearrowformat=False;useconnectionpooling=False;uselegacysql=False;usequerycache=True;userdefinedviews='';usestorageapi=True;verbosity=2;views='';waitforbatchresults=True 2024-09-12T19:47:09.645-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT * FROM SYS_SQLINFO] 2024-09-12T19:47:09.645-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT * FROM SYS_SQLINFO] Success: (0 ms) 2024-09-12T19:47:09.645-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT * FROM sys_tabletypes] 2024-09-12T19:47:09.645-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT * FROM sys_tabletypes] Success: (0 ms) 2024-09-12T19:47:11.268-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT [NAME], [VALUE] FROM [SYS_SQLINFO]] 2024-09-12T19:47:11.269-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT [NAME], [VALUE] FROM [SYS_SQLINFO]] Success: (1 ms) 2024-09-12T19:47:12.267-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT [VALUE] FROM [SYS_SQLINFO] WHERE [NAME] = 'IDENTIFIER_PATTERN'] 2024-09-12T19:47:12.267-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT [VALUE] FROM [SYS_SQLINFO] WHERE [NAME] = 'IDENTIFIER_PATTERN'] Success: (0 ms) 2024-09-12T19:47:12.314-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] 2024-09-12T19:47:12.314-06:00 2 [15|Q-Id] [EXEC|Parsed] Parameter: table = history_test 2024-09-12T19:47:12.345-06:00 2 [15|Q-Id] [META|Schema] Executing column schema query: [history_test] 2024-09-12T19:47:12.408-06:00 2 [15|Q-Id] [HTTP|Req: 5] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables/history_test?view=basic 2024-09-12T19:47:12.508-06:00 2 [15|Q-Id] [HTTP|Res: 5] HTTP/1.1 200 OK, 461 Bytes Transferred 2024-09-12T19:47:12.508-06:00 2 [15|Q-Id] [HTTP|Res: 5] Request completed in 132 ms. 2024-09-12T19:47:12.533-06:00 1 [15|Q-Id] [META|Schema] Executed column schema query: [history_test] Success: 5 results (188 ms) 2024-09-12T19:47:12.533-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] Success: (219 ms) 2024-09-12T19:47:12.580-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] 2024-09-12T19:47:12.580-06:00 2 [15|Q-Id] [EXEC|Parsed] Parameter: table = history_test__r_429933948 2024-09-12T19:47:12.580-06:00 2 [15|Q-Id] [META|Schema] Executing column schema query: [history_test__r_429933948] 2024-09-12T19:47:12.580-06:00 2 [15|Q-Id] [HTTP|Req: 6] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables/history_test__r_429933948?view=basic 2024-09-12T19:47:12.673-06:00 2 [15|Q-Id] [HTTP|Res: 6] HTTP/1.1 404 Not Found, 189 Bytes Transferred 2024-09-12T19:47:13.129-06:00 2 [15|Q-Id] [HTTP|Res: 6] Error: [404] Not found: Table tfo-us-dev-synops-dl-raw:aimi.history_test__r_429933948. Stack: at dbo230F.m.Aq(String ) at dbo230F.yG.z(String ) 2024-09-12T19:47:13.129-06:00 1 [15|Q-Id] [META|Schema] Executed column schema query: [history_test__r_429933948] Error: [404] Not found: Table tfo-us-dev-synops-dl-raw:aimi.history_test__r_429933948. Hint: Google BigQuery identifiers are case-sensitive. Please make sure that the catalog, schema, table and procedure names are spelled in the correct case. 2024-09-12T19:47:13.129-06:00 1 [15|Q-Id] [SQL |Transc] [404] Not found: Table tfo-us-dev-synops-dl-raw:aimi.history_test__r_429933948. Hint: Google BigQuery identifiers are case-sensitive. Please make sure that the catalog, schema, table and procedure names are spelled in the correct case. 2024-09-12T19:47:13.129-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] Success: (549 ms) 2024-09-12T19:47:13.176-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [CREATE TABLE [history_test__r_429933948]([ID] UUID, [userName] VARCHAR(50), [AccessedOn] TIMESTAMP, [Token] VARCHAR(1800), [_cdatasync_deleted] BIT, PRIMARY KEY([ID]))] 2024-09-12T19:47:13.238-06:00 2 [15|Q-Id] [HTTP|Req: 7] POST https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables 2024-09-12T19:47:13.441-06:00 2 [15|Q-Id] [HTTP|Res: 7] HTTP/1.1 200 OK, 530 Bytes Transferred 2024-09-12T19:47:13.441-06:00 2 [15|Q-Id] [HTTP|Res: 7] Request completed in 234 ms. 2024-09-12T19:47:13.457-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [RESET SCHEMA CACHE] 2024-09-12T19:47:13.457-06:00 2 [15|Q-Id] [META|MemSto] MemoryMetadataStorage 2024-09-12T19:47:13.457-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [RESET SCHEMA CACHE] Success: (0 ms) 2024-09-12T19:47:13.457-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [CREATE TABLE [history_test__r_429933948]([ID] UUID, [userName] VARCHAR(50), [AccessedOn] TIMESTAMP, [Token] VARCHAR(1800), [_cdatasync_deleted] BIT, PRIMARY KEY([ID]))] Success: (281 ms) 2024-09-12T19:47:15.977-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [INSERT INTO [history_test__r_429933948] ([ID], [userName], [AccessedOn], [Token], [_cdatasync_deleted]) SELECT [ID], [userName], [AccessedOn], [Token], [_cdatasync_deleted] FROM [history_test__r_429933948@INSERT#Temp]] 2024-09-12T19:47:15.993-06:00 2 [15|Q-Id] [META|Schema] Executing table schema query: [] 2024-09-12T19:47:16.025-06:00 2 [15|Q-Id] [HTTP|Req: 8] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables?maxResults=1000 2024-09-12T19:47:16.152-06:00 2 [15|Q-Id] [HTTP|Res: 8] HTTP/1.1 200 OK, 1113 Bytes Transferred 2024-09-12T19:47:16.152-06:00 2 [15|Q-Id] [HTTP|Res: 8] Request completed in 127 ms. 2024-09-12T19:47:16.152-06:00 1 [15|Q-Id] [META|Schema] Executed table schema query: Table: [] Success: 0 results (159 ms) 2024-09-12T19:47:16.214-06:00 2 [15|Q-Id] [META|Schema] Executing column schema query: [history_test__r_429933948] 2024-09-12T19:47:16.230-06:00 2 [15|Q-Id] [HTTP|Req: 9] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables/history_test__r_429933948?view=basic 2024-09-12T19:47:16.339-06:00 2 [15|Q-Id] [HTTP|Res: 9] HTTP/1.1 200 OK, 476 Bytes Transferred 2024-09-12T19:47:16.339-06:00 2 [15|Q-Id] [HTTP|Res: 9] Request completed in 109 ms. 2024-09-12T19:47:16.339-06:00 1 [15|Q-Id] [META|Schema] Executed column schema query: [history_test__r_429933948] Success: 5 results (125 ms) 2024-09-12T19:47:16.919-06:00 2 [15|Q-Id] [META|Schema] Executing column schema query: [history_test__r_429933948] 2024-09-12T19:47:16.919-06:00 2 [15|Q-Id] [HTTP|Req: 10] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables/history_test__r_429933948?view=basic 2024-09-12T19:47:17.041-06:00 2 [15|Q-Id] [HTTP|Res: 10] HTTP/1.1 200 OK, 472 Bytes Transferred 2024-09-12T19:47:17.041-06:00 2 [15|Q-Id] [HTTP|Res: 10] Request completed in 122 ms. 2024-09-12T19:47:17.041-06:00 1 [15|Q-Id] [META|Schema] Executed column schema query: [history_test__r_429933948] Success: 5 results (122 ms) 2024-09-12T19:47:19.946-06:00 2 [15|Q-Id] [HTTP|Req: 11] POST https://bigquery.googleapis.com/upload/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/jobs?uploadType=multipart 2024-09-12T19:47:20.908-06:00 2 [15|Q-Id] [HTTP|Res: 11] HTTP/1.1 200 OK, 1898 Bytes Transferred 2024-09-12T19:47:20.908-06:00 2 [15|Q-Id] [HTTP|Res: 11] Request completed in 994 ms. 2024-09-12T19:47:21.930-06:00 2 [15|Q-Id] [HTTP|Req: 12] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/jobs/job_ClPvebe1y0Iee3A1dLk206iNxJGq?location=US 2024-09-12T19:47:22.004-06:00 2 [15|Q-Id] [HTTP|Res: 12] HTTP/1.1 200 OK, 744 Bytes Transferred 2024-09-12T19:47:22.004-06:00 2 [15|Q-Id] [HTTP|Res: 12] Request completed in 74 ms. 2024-09-12T19:47:23.010-06:00 2 [15|Q-Id] [HTTP|Req: 13] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/jobs/job_ClPvebe1y0Iee3A1dLk206iNxJGq?location=US 2024-09-12T19:47:23.088-06:00 2 [15|Q-Id] [HTTP|Res: 13] HTTP/1.1 200 OK, 744 Bytes Transferred 2024-09-12T19:47:23.088-06:00 2 [15|Q-Id] [HTTP|Res: 13] Request completed in 78 ms. 2024-09-12T19:47:24.089-06:00 2 [15|Q-Id] [HTTP|Req: 14] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/jobs/job_ClPvebe1y0Iee3A1dLk206iNxJGq?location=US 2024-09-12T19:47:24.183-06:00 2 [15|Q-Id] [HTTP|Res: 14] HTTP/1.1 200 OK, 941 Bytes Transferred 2024-09-12T19:47:24.183-06:00 2 [15|Q-Id] [HTTP|Res: 14] Request completed in 94 ms. 2024-09-12T19:47:24.183-06:00 2 [15|Q-Id] [EXEC|Page ] Page successful: 1 results (7984 ms) 2024-09-12T19:47:24.199-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [INSERT INTO [history_test__r_429933948] ([ID], [userName], [AccessedOn], [Token], [_cdatasync_deleted]) SELECT [ID], [userName], [AccessedOn], [Token], [_cdatasync_deleted] FROM [history_test__r_429933948@INSERT#Temp]] Success: (8000 ms) 2024-09-12T19:47:24.199-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [INSERT INTO [history_test__r_429933948] ([ID], [userName], [AccessedOn], [Token], [_cdatasync_deleted]) SELECT [ID], [userName], [AccessedOn], [Token], [_cdatasync_deleted] FROM [history_test__r_429933948@INSERT#Temp]] Success: (8222 ms) 2024-09-12T19:47:24.214-06:00 2 [15|Q-Id] [SQL |Bulk ] Executed batch INSERT on [history_test__r_429933948]. Operations: 100000. Affected rows: 100000. Failures: 0. 2024-09-12T19:47:24.261-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] 2024-09-12T19:47:24.261-06:00 2 [15|Q-Id] [EXEC|Parsed] Parameter: table = history_test 2024-09-12T19:47:24.261-06:00 2 [15|Q-Id] [META|Schema] Executing column schema query: [history_test] 2024-09-12T19:47:24.277-06:00 2 [15|Q-Id] [HTTP|Req: 15] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables/history_test?view=basic 2024-09-12T19:47:24.389-06:00 2 [15|Q-Id] [HTTP|Res: 15] HTTP/1.1 200 OK, 461 Bytes Transferred 2024-09-12T19:47:24.389-06:00 2 [15|Q-Id] [HTTP|Res: 15] Request completed in 128 ms. 2024-09-12T19:47:24.389-06:00 1 [15|Q-Id] [META|Schema] Executed column schema query: [history_test] Success: 5 results (128 ms) 2024-09-12T19:47:24.389-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] Success: (128 ms) 2024-09-12T19:47:24.389-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [DROP TABLE [history_test]] 2024-09-12T19:47:24.408-06:00 2 [15|Q-Id] [HTTP|Req: 16] DELETE https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables/history_test 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [HTTP|Res: 16] HTTP/1.1 204 No Content, 0 Bytes Transferred 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [HTTP|Res: 16] Request completed in 119 ms. 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [RESET SCHEMA CACHE] 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [META|MemSto] MemoryMetadataStorage 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [RESET SCHEMA CACHE] Success: (0 ms) 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [DROP TABLE [history_test]] Success: (135 ms) 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [select * from sys_options] 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [select * from sys_options] Success: (0 ms) 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [select * from sys_connection_properties] 2024-09-12T19:47:24.524-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [select * from sys_connection_properties] Success: (0 ms) 2024-09-12T19:47:24.539-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [ALTER TABLE [history_test__r_429933948] RENAME TO [history_test]] 2024-09-12T19:47:24.571-06:00 2 [15|Q-Id] [HTTP|Req: 17] POST https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/queries 2024-09-12T19:47:25.840-06:00 2 [15|Q-Id] [HTTP|Res: 17] HTTP/1.1 200 OK, 231 Bytes Transferred 2024-09-12T19:47:25.840-06:00 2 [15|Q-Id] [HTTP|Res: 17] Request completed in 1269 ms. 2024-09-12T19:47:25.840-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [ALTER TABLE [history_test__r_429933948] RENAME TO [history_test]] Success: (1301 ms) 2024-09-12T19:47:25.840-06:00 2 [15|Q-Id] [EXEC|Parsed] Executing query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] 2024-09-12T19:47:25.840-06:00 2 [15|Q-Id] [EXEC|Parsed] Parameter: table = history_test__r_429933948 2024-09-12T19:47:25.840-06:00 2 [15|Q-Id] [META|Schema] Executing column schema query: [history_test__r_429933948] 2024-09-12T19:47:25.840-06:00 2 [15|Q-Id] [HTTP|Req: 18] GET https://bigquery.googleapis.com/bigquery/v2/projects/tfo-us-dev-synops-dl-raw/datasets/aimi/tables/history_test__r_429933948?view=basic 2024-09-12T19:47:25.937-06:00 2 [15|Q-Id] [HTTP|Res: 18] HTTP/1.1 404 Not Found, 191 Bytes Transferred 2024-09-12T19:47:25.937-06:00 2 [15|Q-Id] [HTTP|Res: 18] Error: [404] Not found: Table tfo-us-dev-synops-dl-raw:aimi.history_test__r_429933948. Stack: at dbo230F.m.Aq(String ) at dbo230F.yG.z(String ) 2024-09-12T19:47:25.937-06:00 1 [15|Q-Id] [META|Schema] Executed column schema query: [history_test__r_429933948] Error: [404] Not found: Table tfo-us-dev-synops-dl-raw:aimi.history_test__r_429933948. Hint: Google BigQuery identifiers are case-sensitive. Please make sure that the catalog, schema, table and procedure names are spelled in the correct case. 2024-09-12T19:47:25.937-06:00 1 [15|Q-Id] [SQL |Transc] [404] Not found: Table tfo-us-dev-synops-dl-raw:aimi.history_test__r_429933948. Hint: Google BigQuery identifiers are case-sensitive. Please make sure that the catalog, schema, table and procedure names are spelled in the correct case. 2024-09-12T19:47:25.937-06:00 2 [15|Q-Id] [EXEC|Messag] Executed query: [SELECT *, IsPseudoColumn FROM sys_tablecolumns WHERE TableName = @table] Success: (97 ms) 2024-09-12T19:47:28.213-06:00 1 [15|Q-Id] [INFO|Connec] Closed GoogleBigQuery connection