external_table()

References an external table by name.

external_table('StormEvent')

Note

  • The external_table function has similar restrictions as the table function.
  • Standard query limits apply to external table queries as well.

Syntax

external_table ( TableName [, MappingName ] )

Arguments

  • TableName: The name of the external table being queried. Must be a string literal referencing an external table of kind blob, adl or sql.

  • MappingName: An optional name of the mapping object that maps the fields in the actual (external) data shards to the columns output by this function.

Next steps