Hi I am trying on spectrify for converting the table into spectrum table, which is failing because of an error in SQLAlchemy step. Not sure, how to associate metadata for the engine to NOT prefix "public" when using non-public schemas such as "my_schema.temp_table_01". While, I saw few discussions/links on this issue... I was not able to resolve the issue. Any help appreciated.
*The problem/Error/Blocker* File "/usr/local/lib/python2.7/site-packages/sqlalchemy_redshift/dialect.py" , line 636, in _get_redshift_relation raise sa.exc.NoSuchTableError(key) sqlalchemy.exc.NoSuchTableError: public.temp_table_01 *The Code: Fails* from spectrify.convert import convert_redshift_manifest_to_parquet from spectrify.utils.schema import get_table_schema sa_table = get_table_schema(sa_engine, 'my_schema. temp_table_01') *The code : Works* import sqlalchemy import spectrify from sqlalchemy import create_engine from spectrify.export import export_to_csv db_conn_str = 'redshift+psycopg2://<username>:<password>@<awshostname>:5439/<database_name>' sa_engine = create_engine(db_conn_str, connect_args={'sslmode': 'prefer'}, echo = True) sa_engine.dialect.has_table(sa_engine.connect(), "temp_table_01", schema='my_schema') #returns TRUE -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.