Search code examples
Redshift: How to join with different key based on conditions...


sqlamazon-web-servicesamazon-redshift

Read More
List top queries by total runtime, execution time, wait/queue time in Redshift?...


sqlamazon-web-servicesamazon-redshift

Read More
Error while reading data from databricks jdbc connection to redshift...


apache-sparkpysparkamazon-redshiftdatabricksazure-databricks

Read More
Moving SUM analytic function from PostgreSQL to Redshift with RANGE window frame clause...


postgresqlamazon-redshiftwindow-functionsrolling-computation

Read More
postgresql - view schema privileges...


sqlpostgresqlamazon-redshift

Read More
Best way to get 1st record per partition: FIRST_VALUE vs ROW_NUMBER...


sqlamazon-redshift

Read More
get values from super type in Redshift...


jsonamazon-redshiftextractsupertype

Read More
Calculate running sum in Spark SQL...


sqlpysparkapache-spark-sqlamazon-redshift

Read More
How do I extract and concatenate values from a list of dictionaries using Jinja?...


sqljinja2amazon-redshiftdbt

Read More
Will help in any way locking a table before upserting on Redshift?...


amazon-web-servicesamazon-redshift

Read More
Why does the information_schema.table_privileges in Redshift not support the truncate type?...


sqldatabaseamazon-web-servicesamazon-redshift

Read More
Can't create a temp table using random data in redshift?...


postgresqlamazon-web-servicesamazon-redshift

Read More
Redshift : New table but Group members can't query...


postgresqlsecuritypermissionsamazon-redshiftsql-grant

Read More
How to make the time of a timestamp the top of the hour?...


amazon-web-servicestimestampamazon-redshiftintervals

Read More
Not able to load from s3 bucket to redshift database...


pythonamazon-web-servicesamazon-s3error-handlingamazon-redshift

Read More
RedShift: Utilizing a field value from one subquery as a field name in an overall query to flatten t...


sqlpostgresqlamazon-redshift

Read More
Lag function - issue...


sqlselectamazon-redshiftlag

Read More
Why does Langchain SQLDatabase connection detects only a few of existing tables?...


sqlsqlalchemyamazon-redshiftopenai-apilangchain

Read More
How to list all tables and their creators (or owners) in Redshift...


amazon-redshift

Read More
Case when with distinct value...


sqlcountamazon-redshiftcasedistinct

Read More
Which sortkey is Redshift's automatic table optimization using for a table with auto sortkey set...


sortingdatabase-designamazon-redshiftquery-optimization

Read More
How to extract key, value items from a .json array field in Redshift?...


sqlamazon-redshift

Read More
How to solve ERROR: operator is not unique: "unknown" - "unknown" in a dynamic S...


sqlstored-proceduresamazon-redshiftplpgsqldynamic-sql

Read More
extract nested fields from dynamodb json format in redshift/ Unmarshall DynamoDB JSON to regular JSO...


amazon-redshiftflattenmaterialized-viewsjson-extract

Read More
Not equal vs IN in AWS Redshift...


performanceamazon-redshiftquery-optimization

Read More
Copy Command Redshift putting quotes around super column values...


amazon-redshift

Read More
SQL query to extract incremental data from a table in SQL Server...


sql-serveramazon-web-servicest-sqlamazon-redshiftaws-glue

Read More
Amazon RSQL concat of two tables with 2 shared columns...


sqlpostgresqlamazon-web-servicesconcatenationamazon-redshift

Read More
dbt is not able to find my source defined in sources.yaml...


yamlamazon-redshiftdbt

Read More
How do I convert a "tbl_df" "tbl" "data.frame" object to a "tbl_R...


rdplyramazon-redshiftdbidbplyr

Read More
BackNext