civis.io.split_schema_tablename

civis.io.split_schema_tablename(table)

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.

Parameters:

table: str

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

Returns:

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.

Raises:

ValueError

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