# User Profile based SQL table not available?

**URL:** <https://community.glideapps.com/t/user-profile-based-sql-table-not-available/68404>\
**Category:** Ask for Help\
**Created:** [December 6, 2023, 5:46am UTC](https://community.glideapps.com/t/user-profile-based-sql-table-not-available/68404 "2023-12-06T05:46:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Edd](https://avatars.discourse-cdn.com/v4/letter/e/8c91f0/32.png) [@Edd](https://community.glideapps.com/u/Edd)\
**Post date:** [December 6, 2023, 5:46am UTC](https://community.glideapps.com/t/user-profile-based-sql-table-not-available/68404/1 "2023-12-06T05:46:05Z")

</div>

Hello,  
I’ve got my users table from a SQL db, but when I click the dropdown to select the source sheet for the ‘user profile’ page it doesn’t show up. I was wondering if this is a limitation of the new SQL feature. Does anyone here know if that’s the case? If so, is there a workaround that I’m not aware of?  
Thanks

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 6, 2023, 5:48am UTC](https://community.glideapps.com/t/user-profile-based-sql-table-not-available/68404/2 "2023-12-06T05:48:31Z")

</div>

Yes, that is a limitation.

A workaround would be to use the Glide API to sync your SQL users table with a native user table in Glide.

---

<div class="post-metadata">

**Author:** ![Edd](https://avatars.discourse-cdn.com/v4/letter/e/8c91f0/32.png) [@Edd](https://community.glideapps.com/u/Edd)\
**Post date:** [December 6, 2023, 6:03am UTC](https://community.glideapps.com/t/user-profile-based-sql-table-not-available/68404/3 "2023-12-06T06:03:20Z")

</div>

Thanks for your quick response Darren!  
I thought about that possibility… In my case I’d use python to delete all the rows and create new ones every time, but I noticed that the rowID is required for deleting… I couldn’t find any info in the documentation on how to delete multiple rows, so I’m trying figure out how I can go about doing that.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [December 6, 2023, 6:09am UTC](https://community.glideapps.com/t/user-profile-based-sql-table-not-available/68404/4 "2023-12-06T06:09:10Z")

</div>

I don’t think I would advise deleting/replacing rows in the User Profile table. At the very least, that would probably mess up any user specific column values.

A better approach I think would be something like the following:

- Get All Rows via the API
- Iterate through your SQL users table, comparing to the response from Glide
- Prepare a batch of mutations to add/edit/delete where necessary.
- Send that back to Glide via the API

The API allows for up to 500 mutations in a single call, so you could make updates in batches of 500.

---

<div class="post-metadata">

**Author:** ![Edd](https://avatars.discourse-cdn.com/v4/letter/e/8c91f0/32.png) [@Edd](https://community.glideapps.com/u/Edd)\
**Post date:** [December 6, 2023, 6:16am UTC](https://community.glideapps.com/t/user-profile-based-sql-table-not-available/68404/5 "2023-12-06T06:16:46Z")

</div>

Ok. I see what you mean.  
Cool. I’ll definitely try that approach.  
Thanks again Darren!