CREATE TABLE ..............................T_MERCADO_BPE_ADQ_SF_P03
			WITH ( format = 'Parquet', 
				   parquet_compression = 'SNAPPY', 
				   partitioned_by = ARRAY['PERIODO'], 
				   external_location= 's3:/............................./T_MERCADO_BPE_ADQ_SF_P03/'
				 )
			AS (
			  
					SELECT CODSBS, 
						   COD_EMPRESA,    
						   SUM(MTOSALDO_REAJUSTADO) AS SALDO_REAJUSTADO,
						   PERIODO
					FROM ...........................T_MERCADO_BPE_ADQ_SF_P02
					WHERE 1 = 1
					AND TIPO_PRODUCTO = 'COL. DIRECTAS'
					AND PRODUCTO IN ('PRESTAMOS','TARJETAS DE CREDITO')
					GROUP BY PERIODO,
							 CODSBS,
							 COD_EMPRESA
			)

Add a code snippet to your website: www.paste.org