Let's go see the SQL query results. Click Buckets on the left side menu, and go to your sql-query-results bucket. There should be a file ending in _csv, which contains the results of the SQL query!

SQL Query requires an IAM token to be used when making API calls. Since IAM tokens expire after 60 minutes, it's advised to create an API Key that will be used to generate an IAM token when the ...

SQL procedures, as database objects stored in a database engine like MySQL, PostgreSQL, BigQuery, etc., are named blocks of SQL queries or code that can be called and executed multiple times from ...

In SQL, you may be able to use any of the following aggregate functions: COUNT() SUM() AVG() MIN() MAX() However, when using any of the above aggregate functions, remember the following extra ...

What is an SQL Window Function? A window is a set of rows or observations in a table or result set. In a table, you may have more than one window depending on how you specify the query.

As you can see, the filter has been folded and the WHERE clause of the SQL query contains the filter on ProductCategoryKey. To stop query folding taking place for this filter transformation you can ...

Scalar functions let you encapsulate a calculation into a stored procedure-like snippet of SQL. It’s common practice to return the results of a scalar function as a column in a SELECT query.