Skip to main content

Redshift

Naming resources in Redshift​

caution

We advise to use the default resource names in the setup script provided in Console. If you need to follow your own naming convention however, please follow the guidelines below and provide Snowplow with the resource names you used through the Redshift setup in BDP Console.

Loader user​

Default name: SNOWPLOW_LOADER_USER

Identifier for the loader user; must be unique for your account.

The user name is a standard SQL identifier and it must:

  • begin with an alphabetic character or underscore character, or a UTF-8 multibyte character two to four bytes long
  • subsequent characters can be alphanumeric characters, underscores, or dollar signs, or UTF-8 multibyte characters two to four bytes long
  • be between 1 and 127 bytes in length, not including quotation marks for delimited identifiers
  • contain no quotation marks and no spaces
  • not be a reserved SQL key word
  • not be PUBLIC

For more details, see Identifier Requirements.

Schema​

Default name: atomic

Specifies the identifier for the schema; must be unique for the database in which the schema is created.

The schema identifier is a standard SQL identifier and it must:

  • begin with an alphabetic character or underscore character, or a UTF-8 multibyte character two to four bytes long
  • subsequent characters can be alphanumeric characters, underscores, or dollar signs, or UTF-8 multibyte characters two to four bytes long
  • be between 1 and 127 bytes in length, not including quotation marks for delimited identifiers
  • contain no quotation marks and no spaces
  • not be a reserved SQL key word
  • not be PUBLIC

For more details, see Identifier Requirements.

Was this page helpful?