Amazon Redshift | Querying and Analysis Flashcards
Will my data warehouse cluster remain available during scaling?
Querying and Analysis
Amazon Redshift | Database
The existing data warehouse cluster remains available for read operations while a new data warehouse cluster gets created during scaling operations. When the new data warehouse cluster is ready, your existing data warehouse cluster will be temporarily unavailable while the canonical name record of the existing data warehouse cluster is flipped to point to the new data warehouse cluster. This period of unavailability typically lasts only a few minutes, and will occur during the maintenance window for your data warehouse cluster, unless you specify that the modification should be applied immediately. Amazon Redshift moves data in parallel from the compute nodes in your existing data warehouse cluster to the compute nodes in your new cluster. This enables your operation to complete as quickly as possible.
Back to top »
Is Amazon Redshift compatible with my preferred business intelligence software package and ETL tools?
Querying and Analysis
Amazon Redshift | Database
Amazon Redshift uses industry-standard SQL and is accessed using standard JDBC and ODBC drivers. You can download Amazon Redshift custom JDBC and ODBC drivers from the Connect Client tab of our Console. We have validated integrations with popular BI and ETL vendors, a number of which are offering free trials to help you get started loading and analyzing your data. You can also go to the AWS Marketplace to deploy and configure solutions designed to work with Amazon Redshift in minutes.
What kinds of queries does Redshift Spectrum support?
Querying and Analysis
Amazon Redshift | Database
You use exactly the same query syntax and have the same query capabilities to access tables in Redshift Spectrum as you have for tables in the local storage of your cluster. External tables are referenced using the schema name defined in the CREATE EXTERNAL SCHEMA command where they were registered.
What happens if a table in my local storage has the same name as an external table?
Querying and Analysis
Amazon Redshift | Database
Just like with local tables, you can use the schema name to pick exactly which one you mean by using schema_name.table_name in your query.
What BI tools and SQL Clients does Redshift Spectrum support?
Querying and Analysis
Amazon Redshift | Database
Redshift Spectrum supports all Amazon Redshift client tools. The client tools can continue to connect to the Amazon Redshift cluster endpoint using ODBC or JDBC connections. No changes are required.
What data formats does Redshift Spectrum support?
Querying and Analysis
Amazon Redshift | Database
Redshift Spectrum currently supports numerous open source data formats, including Avro, CSV, Grok, ORC, Parquet, RCFile, RegexSerDe, SequenceFile, TextFile, and TSV.
What compression formats does Redshift Spectrum support?
Querying and Analysis
Amazon Redshift | Database
Redshift Spectrum currently supports Gzip and Snappy compression.
I use a Hive Metastore to store metadata about my S3 data lake. Can I use Redshift Spectrum?
Querying and Analysis
Amazon Redshift | Database
Yes. The CREATE EXTERNAL SCHEMA command supports Hive Metastores. We do not currently support DDL against the Hive Metastore.
