Creates a table that is the result of a SQL JOIN.
For join details and examples see: Joins. For limitations, see Join Limitations and Cautions.
Input Parameter Description
Name | Type | Description | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
join_table_name | string | Name of the join table to be created, in [schema_name.]table_name format, using standard name resolution rules and meeting table naming criteria. | ||||||||||||||||||||||
table_names | array of strings | The list of table names composing the join, each in [schema_name.]table_name format, using standard name resolution rules. Corresponds to a SQL statement FROM clause. | ||||||||||||||||||||||
column_names | array of strings | List of member table columns or column expressions to be included in the join. Columns can be prefixed with 'table_id.column_name', where 'table_id' is the table name or alias. Columns can be aliased via the syntax 'column_name as alias'. Wild cards '*' can be used to include all columns across member tables or 'table_id.*' for all of a single table's columns. Columns and column expressions composing the join must be uniquely named or aliased--therefore, the '*' wild card cannot be used if column names aren't unique across all tables. | ||||||||||||||||||||||
expressions | array of strings | An optional list of expressions to combine and filter the joined tables. Corresponds to a SQL statement WHERE clause. For details see: expressions. The default value is an empty array ( [] ). | ||||||||||||||||||||||
options | map of string to strings | Optional parameters. The default value is an empty map ( {} ).
|
Output Parameter Description
Name | Type | Description | ||||
---|---|---|---|---|---|---|
join_table_name | string | Value of input parameter join_table_name. | ||||
count | long | The number of records in the join table filtered by the given select expression. | ||||
info | map of string to strings | Additional information. The default value is an empty map ( {} ).
|