You can use the information_schema.locations view to return information about each location in your Firebolt account. The view contains one row for each location. Use a SELECT query to return information about each location as shown in the example below.

To view location information, you must have LIST LOCATION or LIST ANY LOCATION privileges. For more information about location permissions, see CREATE LOCATION.

SELECT
  *
FROM
  information_schema.locations;

Columns in information_schema.locations

Each row has the following columns with information about each location:

Column NameData TypeDescription
location_nameTEXTThe name of the location.
sourceTEXTThe type of the external data source. Firebolt currently supports only AMAZON_S3.
urlTEXTThe data source URL. For Amazon S3, the format is s3://{bucket_name}/{path}.
descriptionTEXTOptional metadata describing the location’s purpose.
location_ownerTEXTThe owner of the location.
createdTIMESTAMPTZThe timestamp when the location was created.

Example

The following query returns information about all locations in your account:

SELECT 
  location_name,
  source,
  url,
  description,
  location_owner,
  created
FROM 
  information_schema.locations;

Notes

  • All identifiers are case-insensitive unless enclosed in double-quotes.
  • For more information about object identifiers, see Object identifiers.