where_clause_suffix-enabled warehouses, we follow the amundsen-databuilder pattern, for those familiar with it. For simplicity, we provide a list of metadata tables (e.g.
information_schema) and their aliases, as well as a list of a few notable column names that are commonly used for filtering. If you write a statement that includes a
%, you'll need to escape it (replace it with
%%), as we use the python library SQLAlchemy to execute your query, and python reserves
%for string formatting.
project_idis already an accepted configuration key), we supply a configuration key
databasewhich enables users to pull data only from specific databases/clusters/catalogs under a connection.
where_clauselike with the other warehouses. You can instead add the
included_tables_regexwith an associated regex expression. If the regex expression is matched, the table will be indexed.
project_id.dataset.table_name, so dataset- level restrictions can also occur here.