Skip to main content
R
rodgerpond
Contributor ⭐️
May 26, 2020
Solved

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

  • May 26, 2020
  • 3 replies
  • 176 views

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. 

    Best answer by rakesh

    Hi @rodgerpond 

    Can you try this? 

    STARTSWITH: Daily_Usage_by_Resource_Class_ 

    This should solve your usecase.

    3 replies

    rakesh
    Gainsight Employee ⭐️
    rakesh
    Lets put your data to work!
    May 26, 2020

    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?

      R
      rodgerpondAuthor
      Contributor ⭐️
      May 26, 2020

      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

       

        rakesh
        Gainsight Employee ⭐️
        rakeshAnswer
        Lets put your data to work!
        June 9, 2020

        Hi @rodgerpond 

        Can you try this? 

        STARTSWITH: Daily_Usage_by_Resource_Class_ 

        This should solve your usecase.

          Terms & ConditionsAccessibility statement