Refresh dataset

user04612
user04612 Member
in Cards, Dashboards, Stories

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
    ColemenWilson Coach
    Answer ✓

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

    Screenshot 2024-04-24 at 6.22.13 PM.png

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

    Screenshot 2024-04-24 at 6.21.34 PM.png

    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

  • user04612
    user04612 Member

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

  • ColemenWilson
    ColemenWilson Coach
    Answer ✓

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

    Screenshot 2024-04-24 at 6.22.13 PM.png

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

    Screenshot 2024-04-24 at 6.21.34 PM.png

    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

  • user04612
    user04612 Member

    Thanks for your help!

Categories