def METHOD_NAME(pg_type, *_):
    """Data type mapping from MySQL to Redshift"""
    return {
        'char': 'CHARACTER VARYING({})'.format(DEFAULT_VARCHAR_LENGTH),
        'character': 'CHARACTER VARYING({})'.format(DEFAULT_VARCHAR_LENGTH),
        'varchar': 'CHARACTER VARYING({})'.format(DEFAULT_VARCHAR_LENGTH),
        'character varying': 'CHARACTER VARYING({})'.format(DEFAULT_VARCHAR_LENGTH),
        'text': 'CHARACTER VARYING({})'.format(LONG_VARCHAR_LENGTH),
        'bit': 'BOOLEAN',
        'varbit': 'NUMERIC NULL',
        'bit varying': 'NUMERIC NULL',
        'smallint': 'NUMERIC NULL',
        'int': 'NUMERIC NULL',
        'integer': 'NUMERIC NULL',
        'bigint': 'NUMERIC NULL',
        'smallserial': 'NUMERIC NULL',
        'serial': 'NUMERIC NULL',
        'bigserial': 'NUMERIC NULL',
        'numeric': 'FLOAT',
        'double precision': 'FLOAT',
        'real': 'FLOAT',
        'bool': 'BOOLEAN',
        'boolean': 'BOOLEAN',
        'date': 'TIMESTAMP WITHOUT TIME ZONE',
        'timestamp': 'TIMESTAMP WITHOUT TIME ZONE',
        'timestamp without time zone': 'TIMESTAMP WITHOUT TIME ZONE',
        'timestamp with time zone': 'TIMESTAMP WITHOUT TIME ZONE',
        'time': 'CHARACTER VARYING({})'.format(SHORT_VARCHAR_LENGTH),
        'time without time zone': 'CHARACTER VARYING({})'.format(SHORT_VARCHAR_LENGTH),
        'time with time zone': 'CHARACTER VARYING({})'.format(SHORT_VARCHAR_LENGTH),
        # ARRAY is all uppercase, because postgres stores it in this format in information_schema.columns.data_type
        'ARRAY': 'CHARACTER VARYING({})'.format(LONG_VARCHAR_LENGTH),
        'json': 'CHARACTER VARYING({})'.format(LONG_VARCHAR_LENGTH),
        'jsonb': 'CHARACTER VARYING({})'.format(LONG_VARCHAR_LENGTH),
    }.get(pg_type, 'CHARACTER VARYING({})'.format(DEFAULT_VARCHAR_LENGTH))