Questions about amazon-redshift-spectrum
Read more about amazon-redshift-spectrum
python (12.9k questions)
javascript (9.2k questions)
reactjs (4.7k questions)
java (4.2k questions)
java (4.2k questions)
c# (3.5k questions)
c# (3.5k questions)
html (3.3k questions)
Error when creating external table in Redshift Spectrum with dbt: cross-database reference not supported
I want to create an external table in Redshift Spectrum from CSV files. When I try doing so with dbt, I get a strange error. But when I manually remove some double quotes from the SQL generated by dbt...
ardaar
Votes: 0
Answers: 0
Load Redshift Spectrum external table with CSVs with differing column order
This got no answer and I have a similar question, though I'll expand it.
Suppose I have 3 CSV files in s3://test_path/. I want to create an external table and populate it with the data in these CSVs. ...
ardaar
Votes: 0
Answers: 1
No LOB datatypes in Redshift
We are working on Oracle to Redshift migration project.
As part of migration, we have requirement to create a CLOB value supported column in Redshift.
We have tried in many ways to find out a data typ...
Suman KK
Votes: 0
Answers: 1
Getting Spectrum Scan Error code 15007 on select query on redshift external table
I have created a external table in redshift spectrum.Upon running the select * from table_name, i am getting following error
SQL Error [XX000]: ERROR: Spectrum Scan Error
Detail:
----------------...
nat
Votes: 0
Answers: 2