CREATE TABLE demographics (
cc_num FLOAT64 NOT NULL,
);
CREATE TABLE transactions (
trans_date_trans_time TIMESTAMP,
);
CREATE VIEW transactions_with_demographics as
SELECT
transactions.cc_num,
FROM
...
I'd like to get the following info in JSON: table names & type, view names, view type. e.g., something like that (actual schema is open to discussion):
Given a SQL query
I'd like to get the following info in JSON: table names & type, view names, view type. e.g., something like that (actual schema is open to discussion):