# Big Query /Tables and SQL Server

**URL:** <https://community.glideapps.com/t/big-query-tables-and-sql-server/67775>\
**Category:** Ask for Help\
**Created:** [November 14, 2023, 12:35am UTC](https://community.glideapps.com/t/big-query-tables-and-sql-server/67775 "2023-11-14T00:35:54Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [November 14, 2023, 12:35am UTC](https://community.glideapps.com/t/big-query-tables-and-sql-server/67775/1 "2023-11-14T00:35:55Z")

</div>

I have a data source with 8,000 companies in it. It is used as the master company database with profile data including logo, web-site, linkedin profile, etc.

This table is mainly used as a lookup to match against the company name from other Glide tables ( creating a full record).

I would like to use SQL Server for this master table and have other Glide tables to do a lookup of columns like logo, etc for greater scalability and consistency.

Reading the below I believe Lookup on Big Tables/Queries/SQL Tables is not supported. Correct?

"The following aggregation features are not currently supported for **computed columns** in tables from SQL data sources:

- Rollup column
- Lookup column
- Query column
- Group by
- Filtering, sorting, and searching
- Joined List column
- Relations based on computed columns where the target column is a computed column
- Lookups of relations with multiple matches"

---

<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:** [November 14, 2023, 12:48am UTC](https://community.glideapps.com/t/big-query-tables-and-sql-server/67775/2 "2023-11-14T00:48:13Z")

</div>

> [@MattLB](#):
>
> Reading the below I believe Lookup on Big Tables/Queries/SQL Tables is not supported. Correct?

Incorrect.  
They are supported, but with limitations.  
A lookup of a non-computed column value via a single relation works perfectly fine, for example.