query_create_table = '''CREATE TABLE IF NOT EXISTS AdvertisementData
        (entryID SERIAL PRIMARY KEY,
        Time TIMESTAMP,
        AdvertiserId BIGINT,
        OrderId BIGINT,
        LineItemId BIGINT,
        CreativeId BIGINT,
        CreativeVersion INT,
        CreativeSize VARCHAR(9),
        AdUnitId BIGINT,
        Domain VARCHAR(255),
        CountryId INT,
        RegionId INT,
        MetroId INT,
        CityId INT,
        BrowserId INT,
        OSId INT,
        OSVersion VARCHAR(256),
        TimeUsec2 BIGINT,
        KeyPart VARCHAR(9),
        Product VARCHAR(255),
        RequestedAdUnitSizes VARCHAR(255),
        BandwidthGroupId INT,
        MobileDevice VARCHAR(256),
        IsCompanion BOOLEAN,
        DeviceCategory VARCHAR(256),
        ActiveViewEligibleImpression VARCHAR(256),
        MobileCarrier VARCHAR(256),
        EstimatedBackfillRevenue DECIMAL,
        GfpContentId INT,
        PostalCodeId INT,
        BandwidthId BIGINT,
        AudienceSegmentIds VARCHAR(256),
        MobileCapability VARCHAR(256),
        PublisherProvidedID VARCHAR(64),
        VideoPosition INT,
        PodPosition INT,
        VideoFallbackPosition INT,
        IsInterstitial BOOLEAN,
        EventTimeUsec2 BIGINT,
        EventKeyPart VARCHAR(9),
        YieldGroupCompanyId VARCHAR(256),
        RequestLanguage VARCHAR(256),
        DealId VARCHAR(256),
        SellerReservePrice DECIMAL,
        DealType VARCHAR(256),
        AdxAccountId INT,
        Buyer VARCHAR(256),
        Advertiser VARCHAR(256),
        Anonymous BOOLEAN,
        ImpressionId VARCHAR(256))
        '''
