Skip to content

Instantly share code, notes, and snippets.

View alafanechere's full-sized avatar

Augustin alafanechere

View GitHub Profile
@alafanechere
alafanechere / enable_basic_normalization.sh
Created March 23, 2022 19:14
Enable basic normalization on all connections
#!/bin/bash
# This script creates a basic normalization operation and attaches it
# to all connections in the local Airbyte instance
#
#
# Background / Context
#
# - Currently, a new Airbyte instance does not have a normalization
# operation registered
# - The first connection enabling normalization from the UI triggers the
CREATE TABLE IF NOT EXISTS `country` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`iso` char(2) NOT NULL,
`name` varchar(80) NOT NULL,
`nicename` varchar(80) NOT NULL,
`iso3` char(3) DEFAULT NULL,
`numcode` smallint(6) DEFAULT NULL,
`phonecode` int(5) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;