Yurdik Cervantes yucer-elbt

## athena_query_iso8601_opt_seconds.sql
select format_datetime(current_timestamp, 'YYYY-MM-dd''T''HH:mm''Z''')

## athena_csv_header_pivot.sql
WITH
  HEADER_ROWS AS (
   SELECT
     col0 key
   , col1 value
   , "$path" file
   FROM
     "database"."orders"
   WHERE (NOT (col0 LIKE 'PID_%'))
)

## RDS-Aurora-CloudFormation-Example.yaml
---
AWSTemplateFormatVersion: 2010-09-09
Description: A basic CloudFormation template for an RDS Aurora cluster.
Parameters:
    DatabaseInstanceType:
        Default: db.r3.large
        AllowedValues:
            - db.r3.large
            - db.r3.xlarge
            - db.r3.2xlarge

## presto_iso8601_basic_format.sql
WITH CTE AS (
    SELECT
      concat(
        substr('20220416T070044.243Z', 1, 4), '-',
        substr('20220416T070044.243Z', 5, 2), '-',
        substr('20220416T070044.243Z', 7, 2), 'T',
        substr('20220416T070044.243Z', 10, 2), ':',
        substr('20220416T070044.243Z', 12, 2), ':',
        substr('20220416T070044.243Z', 14)
      ) as ts

## archive.py
import logging

from sqlalchemy.sql import text


_logger = logging.getLogger(__name__)


class ArchivableMixin:
    """Model which can be duplicated via one special materialized view"""
	WITH
	HEADER_ROWS AS (
	SELECT
	col0 key
	, col1 value
	, "$path" file
	FROM
	"database"."orders"
	WHERE (NOT (col0 LIKE 'PID_%'))
	)
	---
	AWSTemplateFormatVersion: 2010-09-09
	Description: A basic CloudFormation template for an RDS Aurora cluster.
	Parameters:
	DatabaseInstanceType:
	Default: db.r3.large
	AllowedValues:
	- db.r3.large
	- db.r3.xlarge
	- db.r3.2xlarge
	WITH CTE AS (
	SELECT
	concat(
	substr('20220416T070044.243Z', 1, 4), '-',
	substr('20220416T070044.243Z', 5, 2), '-',
	substr('20220416T070044.243Z', 7, 2), 'T',
	substr('20220416T070044.243Z', 10, 2), ':',
	substr('20220416T070044.243Z', 12, 2), ':',
	substr('20220416T070044.243Z', 14)
	) as ts
	import logging

	from sqlalchemy.sql import text


	_logger = logging.getLogger(__name__)


	class ArchivableMixin:
	"""Model which can be duplicated via one special materialized view"""