Mehul Sharma mehuled

🎯

Focusing

Show me what's under the hood.

mehuled / redshift-generate-ddl-view.sql

Last active April 24, 2020 04:57

Redshift DDL Generation without Encoding & Sort Key Styles.


	--CREATE THE VIEW TO GENERATE DDL

	-- Orginal DDL courtesy : https://github.com/awslabs/amazon-redshift-utils/blob/master/src/AdminViews/v_generate_tbl_ddl.sql

	CREATE OR REPLACE VIEW admin.v_generate_tbl_ddl
	AS
	SELECT
	table_id
	,REGEXP_REPLACE (schemaname, '^zzzzzzzz', '') AS schemaname