Hi @vamsi_simbus, I haven't used this specific listing, but I can answer the parts that come down to how Marketplace and Delta Sharing work, which should help while you wait.
Direction. Delta Sharing is one-way and read-only. The provider (Kinaxis) shares tables, you mount the share as a read-only catalog in Unity Catalog, and you query it. There's no write path back to the provider through the share. If you want results to go back into Maestro, that has to happen some other way, usually through Maestro's own integration/import options, and that's a question for Kinaxis rather than Databricks.
Access and approval. For listings that say "Request access" (rather than instant access), the provider approves the request, not Databricks. So the delay is on the Kinaxis side. Since the data is your own Maestro planning data, I'd expect them to need an existing Maestro customer relationship to tie the share to the right tenant, but I'd confirm that with your Kinaxis account team. Pinging them directly with the date of your Marketplace request is probably the fastest way to get it moving.
What data comes through. The exact tables are defined by Kinaxis, so the listing page and their docs are the source of truth. Once you're approved, you can check it yourself in a couple of minutes:
SHOW SCHEMAS IN kinaxis_share; -- whatever you name the catalog
SHOW TABLES IN kinaxis_share.<schema>;
DESCRIBE TABLE EXTENDED kinaxis_share.<schema>.<table>;
One practical tip: treat the shared catalog as your bronze layer. Grant read on it to a small group, and build your own silver/gold tables from it in your catalog, so your pipelines don't break if the provider changes a column.
Hope that helps, and if you do get access, it'd be great to hear back what the datasets look like.