This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have GCP project which use bigquery schedules queries. Now I'm trying
to import these scheduled queries in bigquery to terraform plan. But it
gives me the following error message when i runt this command. terraform
plan -generate-config-out=generat<!-- -->...
Hi,I'm trying to find solution to tune my indexes, identify & fix
inconsistent index and index recommendation solutions to my cloud SQL
mysql instance. Currently, I'm using query insights to tune my queries
and manually run "EXPLAIN" on queries to fi...
I am performing MSSql to bigquery data pipeline job using jdbc to
bigquery template in dataflow.Since, I'm working with old MsSQL server
version I'm building Change Data Capture logic on my own and capture
changes and store it in the separate table.A...
Hi Im trying to build data fusion replication job from ms sql server
(cloud sql) to big query. Both data fusion and cloud sql instances is
using private IP. I have configured peering from both tenant project to
VPC network and setup sql-auth proxy. N...
Im trying to build google data fusion pipeline to load data from MS SQL
server to Big Query. The source (MS Sql server - 2016 standard) is
running on GCP VM. I can connect to sql instance using public IP without
any issue. Im using Big Query connecto...
My issue is related to provided ID.Once i changed the id to this format
as mentioned in @ms4446
responseprojects/[PROJECT_ID]/locations/[LOCATION]/transferConfigs/[TRANSFER_CONFIG_ID]it
resolved the issue.Thanx a lot for your detailed explanation and...
Hi @ms4446 ,Thank you so much for your help and detailed explanation.
So, in order to run this, i have to create custom template, right? So,
my another question is, when i create the custom template, do i have to
create classic or flex template? What...
Hi @guillermo56 ,Your using JDBC driver version 12 downloaded from
Microsoft? or the driver available on data fusion HUB? Initially i was
downloaded the JDBC driver version 12 from Microsoft website and deploy
it to data fusion. It gives me this erro...
Thank you @Aris_O for pointing me to correct direction.As you have
mentioned, the issue is related to data type mismatch between source and
destination (Big Query)