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;
