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 [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
