How to define schema in Redshift about spark-redshift HOT 2 CLOSED

Hi @bbnsumanth,

You should be able to pass schema-qualified table names in order to read or write tables from other schemas. For instance, you should be able to pass my_schema.my_table_name as the value of the dbtable parameter. The spark-redshift library also knows how to respect quoting rules, so it should be capable of handling quoted schema or table names (in case you happen to want a table or schema name which contains a dot), e.g. dbtable="\"foo.bar\".baz".

If you're interested in learning how schema-qualified table names are handled internally, take a look at #102, which fixed some bugs related to this (for this reason, make sure that you're using the latest version of spark-redshift (0.5.2)).

Hope this helps!

from spark-redshift.

Thank you,it is very helpful.

from spark-redshift.