Amazon Redshift is a petabyte-scale data warehousing service using existing business intelligence tools to analyze the data.
Does Redshift support JSON fields, like Postgresql's json data type? If so what do I do to use it?
json amazon-redshiftI have a very large Redshift database that contains billions of rows of HTTP request data. I have a table …
sql amazon-redshiftWhen I run the SQL Query: select generate_series(0,g) from ( select date(date1) - date(date2) as g from …
amazon-redshift generate-seriesPart One : I tried glue crawler to run on dummy csv loaded in s3 it created a table but when …
amazon-web-services csv amazon-redshift amazon-athena aws-glueBelow is an example of what I'm trying to achieve in a Redshift Database. I have a variable current_value …
sql amazon-redshift lag window-functionsI'm kicking tires on BI tools, including, of course, Tableau. Part of my evaluation includes correlating the SQL generated by …
sql amazon-redshift tableau-apiI am using Kinesis firehose to transfer data to Redshift via S3. I have a very simple csv file that …
amazon-web-services amazon-s3 amazon-redshift amazon-kinesis-firehoseMy Redshift cluster is in a private VPC. I've written the following AWS Lamba in Node.js which should connect …
aws-lambda amazon-redshift amazon-vpcI am looking to Copy data within databases on Amazon Redshift. Before this, I was copying data from a Redshift …
postgresql amazon-web-services amazon-s3 amazon-redshift amazon-data-pipelineI have already tried the common PostgreSQL answer, but seems like it doesn't work with Redshift: SELECT * FROM VALUES (1) AS …
sql postgresql amazon-redshift set-returning-functions