I think it would be good to investigate whether there is an API we can pull from instead of from the sheet. We'd like the data on all the tabs, but it isn't formatted well for ingestion, and they do analysis in the sheets.

Thanks, the data for each of these lives (or will soon live) in MinIO, and once these are finalized, the schemas won't change (or only very rarely, like once a year) between ingestion runs.

Got it, sounds good. Since it sounds like this won't require SRE or data engineering work, I've captured the reporting and modeling work in Asana, and we can pick up the conversation there. | Task

This can be closed, right, since the mapping is being done in Civi?

@HAhmed-WMF are you still unable to access Turnilo?

@JMando and @AStein-WMF, is it okay to close?

Hi @Dwisehaupt -- could you send over the password for my new SSL client certificate? Thanks!

Thanks for looking into this.

Sounds like the right prioritization!

Checking in on this :)

Looks like David Booke authored the ticket a year ago.

Let's get @JMando 's input!

@AStein-WMF Feel free to close if this is a duplicate.

Closing, since we are tracking the Analytics work for the integration with Sage/Intacct in Asana.

Yes, good find!

Also adding @CHudson-WMF, as she has been modeling recurring giving in dbt.

Hi @jcrespo! Thanks. Would love to hear more about your experience with MinIO and any learnings.

This will be a big improvement, thanks so much!

Closing this out in order to track it in Asana for the FR-Analytics team 👍🏼

Will do. I believe she's on leave for the next week or two, so will let you know.

This work will unblock our survey answers model which we'd like in place in January ahead of @NNgu-WMF's thank-you survey analysis work.

Sounds good, if there are no infra / hardware aspects to vet.

We've promised to turn on self-serve access in Metabase by July 31st. : ) Do you think that timeline will work?

Oops, thanks! Thought I had unchecked all the boxes but must have missed
some.

Hi @AStein-WMF. I'm raising the priority for this ticket. After the Google Sheets integration, I believe this is the next most pressing data engineering effort for the Analytics team. It's a blocker for giving the fundraising team edit access in Metabase, because we'd like for them to have visibility into the field-level documentation in order to begin to explore that data on their own.

I support DerHexer's NDA LDAP access so they can evaluate their fundraising banner performance.

Tickets and Tags tables, per @KHancock99

Resolved. Thank you.

Looks like this may be a duplicate.

And thanks for your help! : )

Hi Tyler,