How to use alternative schema besides dbo?

[brdhunga]

For example if I have a schema 'Raw' where the tables lives, how do i specify that?

[ATLJoeReed]

I've not used this library in a while, but I looked at my code, and I'm doing bulk_inserts (https://github.com/zillow/ctds/blob/master/doc/bulk_insert.rst), and the first parameter is the table to insert into. I just used the below pattern to specify the table.

bulk_insert_table = f"{schema}.{table}"

Also, just a plug for the library, this is blazing fast. I'm sure I will be using this library again in the future. Thank you, Zillow!

[HuangRicky]

this is a generic question abour db names. you can reference a table DB.schema.TB by following method:

if you current db is DB, and default schema is schema, just use TB

DB..TB DB.schema.TB schema.TB

so, i always use the full name DB.schema.TB so i never had the issue you have. i highly recommend you do the same.

this has little to do with ctds.

On Wed, Oct 21, 2020, 10:09 PM brdhunga notifications@github.com wrote:

For example if I have a schema 'Raw' where the tables lives, how do i specify that?

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/zillow/ctds/issues/71, or unsubscribe https://github.com/notifications/unsubscribe-auth/AEWEAWL6HHIUFMEXBCW42NDSL6H3ZANCNFSM4S2RNX7A .

[joshuahlang]

Seems as though the question was answered. I'm going to resolve this.