Refresh dataset

I am trying to refresh my dataset (google sheet), And i do not see a drag and drop file in the details section of settings. I am not sure how else to do it, and my data preview is not showing the new data I have in my sheet

Best Answer

  • ColemenWilson
    Answer ✓

    To refresh your google sheets dataset:
    1. Go to the data center:

    2. Locate your dataset and click into it.
    3. Then click the kebab icon in the top right and click "Run Now"

    If you data is an ETL output, you'll need to repeat steps 1 & 2 above and then:
    4. Click the kebab icon and click "View Dataflow"
    5. Click the kebab icon and click "Run"

    To answer your second question, yes - you can use the Filter Rows tile in Magic ETL: https://domo-support.domo.com/s/article/360044876614?language=en_US

    If I solved your problem, please select "yes" above

Answers

  • Also, Can I filter to specific rows of my google sheet in the etl and how can i do that?

  • ColemenWilson
    Answer ✓

    To refresh your google sheets dataset:
    1. Go to the data center:

    2. Locate your dataset and click into it.
    3. Then click the kebab icon in the top right and click "Run Now"

    If you data is an ETL output, you'll need to repeat steps 1 & 2 above and then:
    4. Click the kebab icon and click "View Dataflow"
    5. Click the kebab icon and click "Run"

    To answer your second question, yes - you can use the Filter Rows tile in Magic ETL: https://domo-support.domo.com/s/article/360044876614?language=en_US

    If I solved your problem, please select "yes" above

  • Thanks for your help!