Which version of AdventureWorks does this work with? 2017 2012 etc.
i.e. file Stg_DimCustomer.sql has statement

INSERT INTO ##tempCustomer
SELECT
Sales.Client.CustomerID,
Sales.Client.PersonID,
People.PersonDetails.DemographicInfo,
Sales.Client.StoreID,
Sales.Store.Demographics
FROM Sales.Client
LEFT JOIN People.PersonDetails
ON People.PersonDetails.BusinessEntityID = Sales.Client.PersonID
LEFT JOIN Sales.Store
ON Sales.Store.BusinessEntityID = Sales.Client.StoreID
;

I can not find a table or view called Sales.Client in any version of AdventureWorks that I can find ..