Skip to main content
rodgerpond
Contributor ⭐️
May 26, 2020 5:35 PM UTC
Solved

Load S3 through a Rules but need more than date stamp. we get a HASH with every file export

We have a Daily ingest that we are starting to use directly from Looker.  Looker always Ads some Hash to make each file unique.  here is an example.  Daily_Usage_by_Resource_Class_2020-05-14T2103_VvnvxW.csv.  I need to find a way that automates using a starts with, or find a way to Pattern this to a daily ingest. 

    rakesh
    rakeshAnswer
    Lets put your data to work!
    Jun 9, 2020 11:50 AM UTC

    Hi @rodgerpond 

    Can you try this? 

    STARTSWITH: Daily_Usage_by_Resource_Class_ 

    This should solve your usecase.

    View in thread

    3 replies

    rakesh
    Gainsight Employee ⭐️
    rakesh
    Lets put your data to work!
    May 26, 2020 6:06 PM UTC

    Hi @rodgerpond 

    We already support Starts With with S3 files patterns.

    Can you confirm if this works for you? or Is there something that's missing here?

    Translate
      rodgerpondAuthor
      Contributor ⭐️
      May 26, 2020 6:24 PM UTC

      I have tried the Starts with, but the pattern is more than a date pattern. It is a DATE_TIMESTAMP_HASH. when I try Starts with an no Date pattern, file error

       

      Translate
        rakesh
        Gainsight Employee ⭐️
        rakeshAnswer
        Lets put your data to work!
        Jun 9, 2020 11:50 AM UTC

        Hi @rodgerpond 

        Can you try this? 

        STARTSWITH: Daily_Usage_by_Resource_Class_ 

        This should solve your usecase.

        Translate
          Terms & ConditionsAccessibility statement