Hi,
Please see my comments below -
The factual information is the metrics of some keywords and the keywords might change over time, so I want to know how should I design the table, as keeping keywords as a column will be difficult as we have over 1000 keywords and practically keeping so many columns seems impossible.
--- You can try out creating a separate table of keywords and link a relationship wherever it is required
Can you suggest some of the table designing methodologies keeping size and performance in mind.
---https://video2.skills-academy.com/en-us/azure/data-factory/copy-activity-performance
https://video2.skills-academy.com/en-us/azure/data-factory/whitepapers
https://video2.skills-academy.com/en-us/azure/data-factory/copy-activity-performance-features