July 9, 2019 at 12:55 pm
Hi,
Has anyone had any experience of migrating data from Google Big Query into SQL Server?
I've just been given a bit of a task to investigate the viability, their seems to be a lot of documentation on
migrating from SQL to Google Big Query, but not the other way around.
Wondering if anyone knows of any sites that would give me a starting point.
Regards
Simon
July 9, 2019 at 6:01 pm
I haven't done it but read a bit about it. You'd need a driver/provider that works with Big Query. You may want to check this:
Magnitude Simba drivers for BigQuery
There are different third party products for connections to Big Query. This is the one I've seen referenced often:
Sue
May 23, 2020 at 5:21 pm
I used Google Big Query Simba ODBC driver. It works but have some issue with SSIS.
https://cloud.google.com/bigquery/providers/simba-drivers
The above link has Google ODBC Driver download. Installation and configuring DSN are easy. SSIS ODBC source will work fine pulling data from Big Query as would from Oracle and Cloudera.
The issue is here:
SSIS ODBC source will show preview of the first 200 row for both scenarios. But it will pull in Columns for only scenario one NOT scenario two. It seems caused by metadata confusion of the query output. Please help.
Google BigQuery Scenarios one:
WITH Example as
(
select 5 as x, 'foo' as y
union all
select 6 as x, 'bar' as y
)
SELECT * FROM Example;
Google BigQuery Scenarios two:
CREATE TEMP TABLE Example
(
x INT64,
y STRING
);
INSERT INTO Example
VALUES (5, 'foo');
INSERT INTO Example
VALUES (6, 'bar');
SELECT * FROM Example;
June 17, 2020 at 8:30 am
This was removed by the editor as SPAM
April 12, 2021 at 3:10 pm
This was removed by the editor as SPAM
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply