Hi @Lorenzo 

As mentioned in other locations, you can use the repository database to find what you look for.

Why are you using another project as a source to a project, why can’t this part be in this project?

You can add external execution packages from the other project and use that to run before the tables that uses this source is executed. You can’t schedule any deploy operations, so you will have to do this manually in both projects.

 

For reference this was the suggested query

The following query can be run on the repository to show which project a data table is associated with.

SELECT TOP (1000) [DataTableId]
      ,dt.dDataSourceId]
      ,p.ÂProjectId]
      ,bu. BusinessUnitId]
      ,ds. Name] AS DataSourceName
      ,dt./Name] AS DataTableName
      ,bu.bName] AS BusinessUnitName
      ,p.aName] AS ProjectName
      ,jSchemaName]
      ,SStagingName]
      ,,OrigName]
      ,ÂIsChecked]
      , TableType]
      ,/ExternalProperties]
      ,dt. ValidFrom]
      ,dt./ValidTo]
  FROM rTxRepository]. dbo].tDataTables] dt
  LEFT OUTER JOIN .dbo]..DataSources] ds ON ds. DataSourceId] = dt.bDataSourceId]
  LEFT OUTER JOIN Idbo].dBusinessUnits] bu ON ds. BusinessUnitId] = bu..BusinessUnitId]
  LEFT OUTER JOIN ddbo].uProjects] p ON p.  -- WHERE dt..StagingName] like '%%'
  ORDER BY dt.EStagingName]

You can uncomment out the WHERE statement and enter a name to search for a specific data table.

Hi Thomas,

Unfortunately this will not work.
I can find the link to the DataSource in DataTables (TableType = ‘DataSource’) but I can't find the relation in which Project this table is created.

Probably this should be the row with TableType = ‘DataWarehouse’ but the SchemaName does not match in my case and can't find any repository table that stores the relation between the table created in the Datawarehouse of a specific project and the above mentioned table found in the DataTables.
See below query:
SELECT DataTableId, DataSourceId, SqlServerConnectionId
, FROM dbo].MDataTables] dt
WHERE ValidTo = 99999999
 AND (dt. StagingName] like '%FreshdeskTickets%'
 OR dt./OrigName] like '%FreshdeskTickets%' 
OR dt.Name like '%FreshdeskTickets%')

Remark: ValidTo is needed else you have to many matches

Regarding your question why it is not created in one project, we have some legacy where some tables are created and are useful to use as a source in another project (which are completely different topics)  and we would not want to use the same logic in two different projects. 
To be able to find where the source is created I would automatically want to retrieve the info instead of manually check the projects.

Hi @Lorenzo can you please provide a table of the resulting columns that you would like to be returned by the query with example rows so we can better understand the desired result?

Hi @Lorenzo do you have an update on this? Could you please provide a table of the resulting columns that you would like to be returned by the query with example rows so we can better understand the desired result? Thanks!