search

CartoDB / bigquery_fdw

BigQuery Foreign Data Wrapper for PostgreSQL
MIT License
0 stars 0 forks source link

Implement query option #1

Open jgoizueta opened 4 years ago

jgoizueta commented 4 years ago

Add a new OPTION to specify a query to be executed on the BQ side, similarly to the sql_option in odbc_fdw.

When building the SQL query for BQ we'll use the query (as a subquery) instead of a table name, see: https://github.com/CartoDB/bigquery_fdw/blob/38c32188266f412b76d79d77fdc30f23f4ad7bad/src/fdw.py#L259-L260

jgoizueta commented 4 years ago

The name for the new option should be fdw_query for consistency, and it would be incompatible with: