Split a Redshift ‘schema.tablename’ string

Remember that special characters (such as ‘.’) can only be included in a schema or table name if delimited by double-quotes.

table: str

Either a Redshift schema and table name combined with a “.”, or else a single table name.

schema, tablename

A 2-tuple of strings. The schema may be None if the input is only a table name, but the tablename will always be filled.


If the input table is not separable into a schema and table name.