ubiq

Build dashboards & reports in minutes

  • Blog
  • What is Ubiq
  • Free Trial

Redshift

How to Add column in Redshift

January 13, 2021January 13, 2021 Ubiq Redshift
how to add column in redshift

Sometimes you may need to add column in Redshift. Here is how to add column in Redshift database.

Continue reading


How To Truncate Table in Redshift

January 12, 2021January 12, 2021 Ubiq Redshift
how to truncate table in redshift

Sometimes you may need to empty table in Redshift. Here is how to truncate table in Redshift.

Continue reading


How to Rename Table in Redshift

January 8, 2021January 8, 2021 Ubiq Redshift
rename table in redshift

Sometimes you may need to change name of database table in Redshift. Here is how to rename table in Redshift.

Continue reading


How to Drop Table in Redshift

December 29, 2020December 29, 2020 Ubiq Redshift
drop table in redshift

Sometimes you may need to delete table or remove table in Redshift. Here is how to drop table in Redshift.

Continue reading


How To Copy Table in Redshift

December 16, 2020December 21, 2020 Ubiq Redshift
copy table in redshift

Sometimes you may need to duplicate table in Redshift or create backup table. Here is how to copy table in Redshift.

Continue reading


How to Remove Not Null Constraint in Redshift

December 14, 2020December 14, 2020 Ubiq Redshift
remove not null constraint in redshift

Redshift does not allow you to drop not null constraint for columns. Here is how to remove Not Null Constraint in Redshift

Continue reading


How to Create table in Redshift

December 9, 2020December 9, 2020 Ubiq Redshift
create table in redshift

Here is how to create table in Redshift data warehouse

Continue reading


How To Insert Data into Redshift Table

December 1, 2020December 1, 2020 Ubiq Redshift
insert data into redhshift

Here is how to insert data into redshift table. You can use it to insert multiple rows, insert into sortkey and insert into identity column.

Continue reading


How To Alter Column From NULL to NOT NULL

November 23, 2020November 23, 2020 Ubiq MySQL, PostgreSQL, Redshift, SQL Server

Here is how to change column from NULL to NOT NULL in SQL Server, MySQL, PostgreSQL using ALTER TABLE statement.

Continue reading


How to Calculate Running Total in Redshift

March 16, 2020May 17, 2020 Ubiq PostgreSQL, Redshift
calculate running total in redshift

Cumulative Total allows you to track running totals over time. Here’s how to calculate running total in Redshift.

Continue reading


Posts navigation

Older posts

About Us



Ubiq is a business intelligence & reporting tool that makes it easy to get insights from data. Build business dashboards, charts & reports in minutes.Try it Today!




  • Popular
  • Recent
  • transpose rows columns dynamically
    How to Transpose Rows to Columns Dynamically in MySQL Feb 12, 2020
  • calculate percentage of column in mysql
    How to Calculate Percentage of Column in MySQL Jan 6, 2020
  • calculate total sales per month in mysql
    How to Calculate Total Sales Per Month in MySQL? Mar 25, 2020
  • How to create a read-only MySQL user? Nov 25, 2013
  • get last record in each group
    How To Get Last Record In Each Group In MySQL May 27, 2020
  • calculate moving average mysql
    How to Calculate Moving Average in MySQL Feb 17, 2020
  • import csv to mysql workbench
    How to Import CSV to MySQL Workbench Apr 30, 2020
  • check value in postgresql array
    How to Check if PostgreSQL Array Contains Value Jan 19, 2021
  • coalesce in mysql
    How to Use Coalesce in MySQL Jan 19, 2021
  • query json column in mysql
    How to Query JSON column in MySQL Jan 18, 2021
  • avoid inserting duplicate records in mysql
    How To Avoid Inserting Duplicate Records in MySQL Jan 18, 2021
  • update array in postgresql
    How to Update Array in PostgreSQL Jan 15, 2021
  • get multiple count in mysql
    How to Get Multiple Counts With Single Query in MySQL Jan 15, 2021
  • convert datetime to utc in mysql
    How to Convert datetime to UTC in MySQL Jan 14, 2021
dazzling Theme by Colorlib Powered by WordPress